﻿using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using System.Data.Sql;

namespace LR4.DAO
{
    public class DAO
    {
        private const string ConnectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=\"D:\\ISTProj\\ist107-ivanov-programming\\ist107-ivanov-programming\\sources\\LR4\\LR4\\App_Data\\Database1.mdf\";Integrated Security=True;User Instance=True";

        public SqlConnection Connection { get; set; }

        
         public void Connect()
         {
            Connection = new SqlConnection(ConnectionString);
            Connection.Open();            
         }


         public void Disconnect()
         {
            Connection.Close();            
         }

    }
}
